03:30

Introducing DAX Video Course

Evaluation Contexts: Example of a Filter Context

…But as we will see we have some specific function to create and handle the filter […] computed by applying the filter context which is active at the grand total. […] context by ourselves. […] contribute together to the creation of…  Watch now

11:10

video course

Measuring performance: Lab 2 - Exercise 2 - Solution

…addcolumn, and then a filter VertiPaq and the calculate at the top. […] after having computed the filter, now it knows that the only products […] and it will build the filter of 2008 green and […] building such a filter is a bit too complex…  Watch now

02:14

Introducing DAX Video Course

Table Functions: Mixing Filters

…592, as it happened earlier, has a filter for green and a filter […] and the filter where you are, this expression always returns the last […] another function in place of a table name. So for example you can write filter of…  Watch now

12:31

Introducing DAX Video Course

Time Intelligence in DAX: Date Table

…After all the theory about evaluation contexts, row context, filter […] context, CALCULATE and how they work together, it’s now time to start using…  Watch now

05:15

Introducing DAX Video Course

Evaluation Contexts and Relationships: Filter Context - Many Tables

…activate bi-directional filtering, the filter doesn’t move from the many side to the one […] And because it is a filter context it will move from the cities table to the orders […] because we start from Europe, the filter from Europe will…  Watch now

04:20

Introducing DAX Video Course

Evaluation Contexts: What is an Evaluation Context?

…any kind of filter here, the result will be the sum of all the sales […] applying a filter context to all calculations so that all the calculations in the […] contribute to the generation of one single filter context […]…  Watch now

03:56

Introducing DAX Video Course

CALCULATE: Filters are Tables

…but keeping any existing filter on the brand, on the […] CALCULATE. CALCULATE partially replaces the filter context. This is […] filter context. […] It can work on the whole filter context, it can work on a single column, on a full table, […] model. In such…  Watch now

14:16

video course

Advanced optimizations: Column filters vs table filters

…and let’s take a look at our filter. What we’re saying here from a […] be: use column filter instead of table filter. Now we’re going to see […] filter into the sales table, that overrides the previous one – and sales […] filter later for something.…  Watch now

03:54

Mastering DAX Video Course

Evaluation contexts: Context errors

…A measure does not contain a row context by default. […] all these expressions are bound to the filter context. […] between the row context and the filter context. […] I mean the currently iterated row in the row context.…  Watch now

16:03

video

Filter Context in DAX

Understanding the difference between a row context and a filter context is the first and most important concept to learn to use DAX correctly. This video introduces the filter context.  Watch now